#encoding:utf-8
CREATE TABLE `<%=beanInfo.tablename%>` (
id BIGINT(20) NOT NULL AUTO_INCREMENT,
<% beanInfo.properties.each do |k, v| %>
    <%=k%> <% if (v=="String")  %>VARCHAR(100)<% elsif (v=="BigString") %>VARCHAR(2000)<% elsif (v=="Date") %>DATE<% elsif (v=="Timestamp") %>DATETIME<% elsif (v=="Long") %>INT(20)<% elsif (v=="BigLong") %>BIGINT(20)<%end%>,
<% end %>
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT